﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LineOfBusinessDataSet1" targetNamespace="http://tempuri.org/LineOfBusinessDataSet1.xsd" xmlns:mstns="http://tempuri.org/LineOfBusinessDataSet1.xsd" xmlns="http://tempuri.org/LineOfBusinessDataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="LineOfBusinessConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="LineOfBusinessConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.LineOfBusiness.AR.Properties.Settings.GlobalReference.Default.LineOfBusinessConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="abcdTableAdapter" GeneratorDataComponentClassName="abcdTableAdapter" Name="abcd" UserDataComponentName="abcdTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LineOfBusinessConnectionString (Settings)" DbObjectName="LineOfBusiness.dbo.abcd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[abcd] ([RecordID], [ItemID], [Color], [Size], [Quantity], [UMID], [CostPrice], [CostAmount], [SalesPrice], [NetAmt], [ItemType], [DeadLines], [GoldAgeID], [SONo], [Note], [CreatedDate], [VoucherNo], [SODate]) VALUES (@RecordID, @ItemID, @Color, @Size, @Quantity, @UMID, @CostPrice, @CostAmount, @SalesPrice, @NetAmt, @ItemType, @DeadLines, @GoldAgeID, @SONo, @Note, @CreatedDate, @VoucherNo, @SODate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RecordID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RecordID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ItemID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Size" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Size" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Quantity" Precision="28" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UMID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UMID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostPrice" Precision="28" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="CostPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CostAmount" Precision="28" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="CostAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalesPrice" Precision="28" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="SalesPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NetAmt" Precision="28" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="NetAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ItemType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DeadLines" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DeadLines" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GoldAgeID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GoldAgeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SONo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SONo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VoucherNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VoucherNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SODate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SODate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RecordID, ItemID, Color, Size, Quantity, UMID, CostPrice, CostAmount, SalesPrice, NetAmt, ItemType, DeadLines, GoldAgeID, SONo, Note, CreatedDate, VoucherNo, SODate FROM dbo.abcd</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RecordID" DataSetColumn="RecordID" />
              <Mapping SourceColumn="ItemID" DataSetColumn="ItemID" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="Size" DataSetColumn="Size" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="UMID" DataSetColumn="UMID" />
              <Mapping SourceColumn="CostPrice" DataSetColumn="CostPrice" />
              <Mapping SourceColumn="CostAmount" DataSetColumn="CostAmount" />
              <Mapping SourceColumn="SalesPrice" DataSetColumn="SalesPrice" />
              <Mapping SourceColumn="NetAmt" DataSetColumn="NetAmt" />
              <Mapping SourceColumn="ItemType" DataSetColumn="ItemType" />
              <Mapping SourceColumn="DeadLines" DataSetColumn="DeadLines" />
              <Mapping SourceColumn="GoldAgeID" DataSetColumn="GoldAgeID" />
              <Mapping SourceColumn="SONo" DataSetColumn="SONo" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="CreatedDate" DataSetColumn="CreatedDate" />
              <Mapping SourceColumn="VoucherNo" DataSetColumn="VoucherNo" />
              <Mapping SourceColumn="SODate" DataSetColumn="SODate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LineOfBusinessDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="LineOfBusinessDataSet1" msprop:Generator_UserDSName="LineOfBusinessDataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="abcd" msprop:Generator_TableClassName="abcdDataTable" msprop:Generator_TableVarName="tableabcd" msprop:Generator_TablePropName="abcd" msprop:Generator_RowDeletingName="abcdRowDeleting" msprop:Generator_RowChangingName="abcdRowChanging" msprop:Generator_RowEvHandlerName="abcdRowChangeEventHandler" msprop:Generator_RowDeletedName="abcdRowDeleted" msprop:Generator_UserTableName="abcd" msprop:Generator_RowChangedName="abcdRowChanged" msprop:Generator_RowEvArgName="abcdRowChangeEvent" msprop:Generator_RowClassName="abcdRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RecordID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnRecordID" msprop:Generator_ColumnPropNameInRow="RecordID" msprop:Generator_ColumnPropNameInTable="RecordIDColumn" msprop:Generator_UserColumnName="RecordID" type="xs:string" />
              <xs:element name="ItemID" msprop:Generator_ColumnVarNameInTable="columnItemID" msprop:Generator_ColumnPropNameInRow="ItemID" msprop:Generator_ColumnPropNameInTable="ItemIDColumn" msprop:Generator_UserColumnName="ItemID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Size" msprop:Generator_ColumnVarNameInTable="columnSize" msprop:Generator_ColumnPropNameInRow="Size" msprop:Generator_ColumnPropNameInTable="SizeColumn" msprop:Generator_UserColumnName="Size" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:decimal" />
              <xs:element name="UMID" msprop:Generator_ColumnVarNameInTable="columnUMID" msprop:Generator_ColumnPropNameInRow="UMID" msprop:Generator_ColumnPropNameInTable="UMIDColumn" msprop:Generator_UserColumnName="UMID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CostPrice" msprop:Generator_ColumnVarNameInTable="columnCostPrice" msprop:Generator_ColumnPropNameInRow="CostPrice" msprop:Generator_ColumnPropNameInTable="CostPriceColumn" msprop:Generator_UserColumnName="CostPrice" type="xs:decimal" />
              <xs:element name="CostAmount" msprop:Generator_ColumnVarNameInTable="columnCostAmount" msprop:Generator_ColumnPropNameInRow="CostAmount" msprop:Generator_ColumnPropNameInTable="CostAmountColumn" msprop:Generator_UserColumnName="CostAmount" type="xs:decimal" />
              <xs:element name="SalesPrice" msprop:Generator_ColumnVarNameInTable="columnSalesPrice" msprop:Generator_ColumnPropNameInRow="SalesPrice" msprop:Generator_ColumnPropNameInTable="SalesPriceColumn" msprop:Generator_UserColumnName="SalesPrice" type="xs:decimal" />
              <xs:element name="NetAmt" msprop:Generator_ColumnVarNameInTable="columnNetAmt" msprop:Generator_ColumnPropNameInRow="NetAmt" msprop:Generator_ColumnPropNameInTable="NetAmtColumn" msprop:Generator_UserColumnName="NetAmt" type="xs:decimal" />
              <xs:element name="ItemType" msprop:Generator_ColumnVarNameInTable="columnItemType" msprop:Generator_ColumnPropNameInRow="ItemType" msprop:Generator_ColumnPropNameInTable="ItemTypeColumn" msprop:Generator_UserColumnName="ItemType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DeadLines" msprop:Generator_ColumnVarNameInTable="columnDeadLines" msprop:Generator_ColumnPropNameInRow="DeadLines" msprop:Generator_ColumnPropNameInTable="DeadLinesColumn" msprop:Generator_UserColumnName="DeadLines" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GoldAgeID" msprop:Generator_ColumnVarNameInTable="columnGoldAgeID" msprop:Generator_ColumnPropNameInRow="GoldAgeID" msprop:Generator_ColumnPropNameInTable="GoldAgeIDColumn" msprop:Generator_UserColumnName="GoldAgeID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SONo" msprop:Generator_ColumnVarNameInTable="columnSONo" msprop:Generator_ColumnPropNameInRow="SONo" msprop:Generator_ColumnPropNameInTable="SONoColumn" msprop:Generator_UserColumnName="SONo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CreatedDate" msprop:Generator_ColumnVarNameInTable="columnCreatedDate" msprop:Generator_ColumnPropNameInRow="CreatedDate" msprop:Generator_ColumnPropNameInTable="CreatedDateColumn" msprop:Generator_UserColumnName="CreatedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VoucherNo" msprop:Generator_ColumnVarNameInTable="columnVoucherNo" msprop:Generator_ColumnPropNameInRow="VoucherNo" msprop:Generator_ColumnPropNameInTable="VoucherNoColumn" msprop:Generator_UserColumnName="VoucherNo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SODate" msprop:Generator_ColumnVarNameInTable="columnSODate" msprop:Generator_ColumnPropNameInRow="SODate" msprop:Generator_ColumnPropNameInTable="SODateColumn" msprop:Generator_UserColumnName="SODate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>